package com.css.crm.dao;

import java.util.List;

import com.css.crm.vo.CustomerTelephoneVo;

/**
 * Interface for DAO on table VP_CUST_TEL
 * 
 * @author AIS
 */
public interface CustomerTelephoneDao extends BaseDao {


	/**
	 * Get all customer telephone record by customer id
	 * 
	 * @param custId
	 *            Customer id to specific record to be retrieved
	 * @return List of customer telephone record(s)
	 */
	List<CustomerTelephoneVo> getCustomerTelephoneByCustId(String custId);

	/**
	 * Create customer telephone record
	 * 
	 * @param customerTelephone
	 *            CustomerTelephoneVo object
	 * @return Row count affected
	 */
	int insertCustomerTelephone(CustomerTelephoneVo customerTelephone);

	/**
	 * Update customer telephone record
	 * 
	 * @param customerTelephone
	 *            Updated CustomerTelephoneVo object
	 * @return Row count affected
	 */
	int updateCustomerTelephoneByPK(CustomerTelephoneVo customerTelephone);

	/**
	 * Delete specific customer telephone record by customer telephone id
	 * 
	 * @param custTelId
	 *            Customer telephone id to specific record to be deleted
	 * @return Row count affected
	 */
	int deleteCustomerTelephoneByPK(Long custTelId);

	/**
	 * Delete customer telephone record(s) by customer id
	 * 
	 * @param custId
	 *            Customer id to specific record(s) to be deleted
	 * @return Row count affected
	 */
	int deleteCustomerTelephoneByCustId(String custId);

}
